PivotTable Properties

Properties

AllowEditData
ApplyAlignmentFormats
ApplyBorderFormats
ApplyFontFormats
ApplyNumberFormats
ApplyPatternFormats
ApplyWidthHeightFormats
AsteriskTotals
AutoFormatID
CacheID
ChartFormatID
ChartFormats
ColumnFields
ColumnHeaderCaption
ColumnItems
CompactData
CompactNewFields
CreatedVersion
CustomListAutoSort
DataCaption
DataFields
DataFieldsPublished
DataOnRows
DefaultDataFieldPosition
DefaultSortOrder
DisableFieldList
EnableDrillDown
EnableDropZones
EnableFieldProperties
EnableWizard
ErrorCaption
FieldPrintTitles
Formats
GrandTotalCaption
GrandTotalsOnColumns
Indent
ItemPrintTitles
LastUpdatedVersion
Location
MdxSubqueriesSupported
MergeTitles
MinimumRefreshableVersion
MissingCaption
MultipleFieldFilters
Name
OutlineDataFields
OutlineNewFields
PageFields
PageHeaderStyleName
PageOverThenDown
PageWrapCount
PivotCache
PivotFields
PreserveFormatting
PrintDrillIndicators
RowFields
RowGrandTotals
RowHeaderCaption
RowItems
ShowCalculatedMembers
ShowDataDropDown
ShowDataToolTips
ShowDrill
ShowDropZones
ShowEmptyColumn
ShowEmptyRow
ShowError
ShowFieldHeaders
ShowItemNames
ShowMemberPropertyToolTips
ShowMissing
ShowMultipleLabels
StopImmersiveUI
Style
SubtotalHiddenItems
TableStyleName
Tag
TotalVisualData
UseAutoFormatting
VacatedStyle